Problem Note 67724: A DB2 error might occur when queries that are passed to the DB2 database contain single quotation marks that are not escaped
 |  |  |  |  |
An error might occur when a query that is being passed to the DB2 database contains an embedded single quotation mark in a character value that is not escaped. The error might look similar to the following:
DB2 ERROR:
RESULT OF SQL STATEMENT:
DSN00104E ILLEGAL SYMBOL " ". SOME SYMBOLS THAT MIGHT BE LEGAL ARE: AT YEAR YEARS MONTH MONTHS DAY DAYS HOUR HOURS MINUTE MINUTES
A DUMP OF THE SQLCA FOR THE GET DIAGNOSTICS REQUEST FOLLOWS: ROW NUMBER: 0 ERROR CONDITION: 1 REASON CODE: 0
SQLCODE: -104 SQLSTATE: 42601 SQLERRP: DSNHPARS
RESULT OF SQL STATEMENT:
DSN00104E ILLEGAL SYMBOL " ". SOME SYMBOLS THAT MIGHT BE LEGAL ARE: AT YEAR YEARS MONTH MONTHS DAY DAYS HOUR HOURS MINUTE MINUTES
A DUMP OF THE SQLCA FOR THE GET DIAGNOSTICS REQUEST FOLLOWS: ROW NUMBER: 0 ERROR CONDITION: 1 REASON CODE: 0
SQLCODE: -104 SQLSTATE: 42601 SQLERRP: DSNHPARS
The issue occurs when the following is true:
- You are running SAS® on the z/OS operating system.
- Your character value contains a Shift Out (SO), hex code x'0E', before the embedded single quotation mark.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to DB2 | z/OS | 9.3 TS1M0 | 9.4 TS1M8 |
A fix for this issue for SAS/ACCESS Interface to DB2 9.44 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/K2R.html#67724A fix for this issue for SAS/ACCESS Interface to DB2 9.43 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/F4B.html#67724| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2021-04-19 16:06:32 |
| Date Created: | 2021-04-06 17:40:55 |